2013-04-05 - 5910.200 - Rel Notes - Contracts - Release 023 #BIReleases2013

Release Notes:

5910.200 - OSA110 - Open Orders by Country and Sales Rep

Admin Info

Purpose
 Including Contract Information in OSA110 - Open Orders by Country and Sales Rep.
Release No
 023
Submitted
 04-05-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Praveen Guntuka
Object(s) Tested By
 Praveen Guntuka

Report Name

OSA110 - Open Orders by Country and Sales Rep

BEx Query

ZMP_OOCON_Q006

‍NEC Crystal Reports Standards Check

1. OSA110 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA110 NEC CR checklist has been sent to NEC and also attached here for reference:
OSA110 NEC CR Standard Check List.xlsx

Summary Level Check

Test Conducted

Group 1 : Sales Organization Name : 5th & Ocean Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 556
 556
 Pass
2
 Confirmed Quantity
 1,314,787
 13,14,787
 Pass
3
 Sales Org Currency
 12,318,694
 12,318,693.61
 Pass
4
 Corporate Currency
 12,318,694
 12,318,693.61
 Pass

Group 1 : Sales Organization Name : EMEA Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 9,081
 9,081
 Pass
2
 Confirmed Quantity
 1,811,878
 1,811,878
 Pass
3
 Sales Org Currency
 15,045,839
 15,045,762.41
 Pass
4
 Corporate Currency
 22,796,424
 22,796,396.41
 Pass
Note: For EMEA Sales, Sales Org Currency and Corporate Currency are not matching with BEx Query values. The difference is £77 and $28 respectively. Considered as successfully validated.

Group 1 : Sales Organization Name : United States Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 36,882
 36,882
 Pass
2
 Confirmed Quantity
 10,841,045
 10,841,045
 Pass
3
 Sales Org Currency
 110,805,162
 110,805,161.77
 Pass
4
 Corporate Currency
 110,805,162
 110,805,161.77
 Pass

Second Level Check

Test Conducted

Group 2 : Sales Organization Name > Fiscal Year : APAC Sales > 2012
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 3
 3
 Pass
2
 Confirmed Quantity
 283
 283
 Pass
3
 Sales Org Currency
 39,358
 39,357.60
 Pass
4
 Corporate Currency
 5,070
 5,069.83
 Pass

Group 2 : Sales Organization Name > Fiscal Year : German Sales > 2013
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 14
 14
 Pass
2
 Confirmed Quantity
 2,549
 2,549
 Pass
3
 Sales Org Currency
 26,650
 26,649.70
 Pass
4
 Corporate Currency
 34,109
 34,108.95
 Pass

Third Level Check

Test Conducted

Group 2 : Sales Organization Name > Fiscal Year > Country : EMEA Web Sales > 2013 > United Kingdom
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 67
 67
 Pass
2
 Confirmed Quantity
 120
 120
 Pass
3
 Sales Org Currency
 2,122.03
 2,122.11
 Pass
4
 Corporate Currency
 3,215.28
 3,215.32
 Pass

Group 2 : Sales Organization Name > Fiscal Year > Country : NEC Korea Sales > 2013 > South Korea
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 33
 33
 Pass
2
 Confirmed Quantity
 23,016
 23,016
 Pass
3
 Sales Org Currency
 441,228,344.00
 441,228,344.00
 Pass
4
 Corporate Currency
 397,105.50
 397,105.51
 Pass

Fourth Level Check

Test Conducted

Group 2 : Sales Organization Name > Fiscal Year > Country > Sales Group : Mexico Sales > 2013 > Mexico > Alex Noguera
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 140
 140
 Pass
2
 Confirmed Quantity
 370,387
 370,387
 Pass
3
 Sales Org Currency
 79,673,880
 79,673,879.89
 Pass
4
 Corporate Currency
 6,453,584
 6,453,584.27
 Pass

Group 2 : Sales Organization Name > Fiscal Year > Country > Sales Group : EMEA Web Sales > 2013 > United Kingdom > NE Retail
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 67
 67
 Pass
2
 Confirmed Quantity
 120
 120
 Pass
3
 Sales Org Currency
 2,122
 2,122.11
 Pass
4
 Corporate Currency
 3,215
 3,215.32
 Pass

Fifth Level Check

Test Conducted

Group 2 : Sales Organization Name > Fiscal Year > Country > Sales Group > Sold-to Party : Latin America Sales > 2013 > Amer.Virgin Is. > Alfredo Alvarez > HABERDASHERS INC DBA URBAN THREADZ - 1008762
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 3
 3
 Pass
2
 Confirmed Quantity
 294
 294
 Pass
3
 Customer Currency
 4,681
 4,681.00
 Pass
4
 Sales Org Currency
 4,681
 4,681.00
 Pass
5
 Corporate Currency
 4,681
 4,681.00
 Pass

Group 2 : Sales Organization Name > Fiscal Year > Country > Sales Group > Sold-to Party : Australia Sales > 2013 > Australia > David Biwar > EMPIRE DISTRIBUTIONS- 1011384
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 11
 11
 Pass
2
 Confirmed Quantity
 571
 571
 Pass
3
 Customer Currency
 7,553
 7,553.22
 Pass
4
 Sales Org Currency
 7,553
 7,553.22
 Pass
5
 Corporate Currency
 7,875
 7,874.99
 Pass

Sixth Level Check

Test Conducted

Group 6 : Sales Organization Name > Fiscal Year > Country > Sales Group > Sold-to Party > Sales Order : Canada Sales > 2013 > Canda > Andreq Haqq > ALL SEASONS SOURCE FOR SPORT > 1429,729.00
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Order Date
 3/11/13
 03/11/2013
 Pass
2
 First Ship
 5/1/13
 05/01/2013
 Pass
3
 Last Ship
 5/7/13
 05/07/2013
 Pass
4
 Cancel Date
 6/1/13
 06/01/2013
 Pass
5
 No. of Orders
 -
 -
 Pass
6
 Confirmed Quantity
 16
 16
 Pass
7
 Customer Currency
 320
 320
 Pass
8
 Sales Org Currency
 320
 320
 Pass
9
 Corporate Currency
 315
 315
 Pass

Group 6 : Sales Organization Name > Fiscal Year > Country > Sales Group > Sold-to Party > Sales Order : United States Sales > 2013 > Australia > Brad Chambers > ACUSHNET AUSTRALIA > 1,324,821.00
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Order Date
 12/2012
 12/20/2012
 Pass
2
 First Ship
 4/20/13
 4/20/2013
 Pass
3
 Last Ship
 4/20/13
 4/20/2013
 Pass
4
 Cancel Date
 4/15/13
 4/15/2013
 Pass
5
 No. of Orders
 -
 -
 Pass
6
 Confirmed Quantity
 936
 936
 Pass
7
 Customer Currency
 4,184
 4,183.92
 Pass
8
 Sales Org Currency
 4,184
 4,183.92
 Pass
9
 Corporate Currency
 4,184
 4,183.92
 Pass

Seventh Level Check

Test Conducted
Group 6 : Sales Organization Name > Fiscal Year > Country > Sales Group > Sold-to Party > Sales Order > Material : APAC Sales > 2012 > Hong Kong > Asian House Accounts > DA HOOD - 1014054 > 1292018 > 10743448
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Material No
 10743448
 10743448
 Pass
2
 Description
 7 PANEL NE X SUBCREW W/GWP NAVY
 7 PANEL NE X SUBCREW W/GWP NAVY
 Pass
3
 Collection Name
 CUSTOM
 CUSTOM
 Pass
4
 Order status
 O
 O
 Pass
5
 Confirmed Quantity
 6
 6
 Pass
6
 Unit Price
 66
 66
 Pass
7
 Customer Currency
 396
 396.00
 Pass
8
 Sales Org Currency
 3,074
 3,074.19
 Pass
9
 Corporate Currency
 396
 396.00
 Pass

Reference Document(Specification)

2013-03-15 - 5910.200 - Spec - Contract Reports